#!/usr/bin/python

import openpyxl

# 打开Excel文件
workbook = openpyxl.load_workbook('/Users/lvxin/Downloads/公会主播5天没有收益.xlsx')

# 选择工作表
sheet = workbook.active  # 或者使用 sheet = workbook['Sheet1'] 指定特定工作表

# 读取数据
i = 0
playerIdStr = ""
for row in sheet.iter_rows(values_only=True):
    if i > 0 :
        if i > 1:
            playerIdStr += ","
        playerIdStr += str(row[0])
    i += 1
print(playerIdStr)
print(len(playerIdStr.split(",")))
